SAPABAP如何将内表与EXCEL导入、导出 |
您所在的位置:网站首页 › sap excel导出 › SAPABAP如何将内表与EXCEL导入、导出 |
SAPABAP 如何将内表与 EXCEL 导入、导出
将内表的数据导出到 EXCEL REPORT ZTEST08.
DATA: BEGIN OF MY_DATA, MANDT LIKE USR02-MANDT, BNAME LIKE USR02-BNAME, ERDAT LIKE USR02-ERDAT, LTIME LIKE USR02-LTIME, END OF MY_DATA.
DATA: IT_DATA LIKE MY_DATA OCCURS 0.
SELECT USR02~MANDT USR02~BNAME USR02~ERDAT USR02~LTIME APPENDING TABLE IT_DATA FROM USR02 UP to 100 rows. * 排序
SORT IT_DATA BY BNAME. INCLUDE OLE2INCL. " 定义 OLE 变量
DATA: EXCEL TYPE OLE2_OBJECT, SHEET TYPE OLE2_OBJECT, CELL TYPE OLE2_OBJECT, WORKBOOK TYPE OLE2_OBJECT,
XLSNAME TYPE STRING VALUE 'C:\sap_usr02.xls', LINE TYPE I VALUE 0. " 行号
|
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |